Number of  cell containing a particular  month

I have a spreadsheet which contains 1,000 rows - each row has a date of birth

I would like to find out how many rows have the month of Apri 2014, May 2014, and so on.

Is there a easy way to do this?

March 5th, 2015 3:34pm

The easiest way is to create a pivot table based on the data table.

Add the date field (column) to the Rows area and to the Values area.

Right-click one of the dates in the Rows area, and select Group... from the context menu,

Group by year and by month.

Free Windows Admin Tool Kit Click here and download it now
March 5th, 2015 3:48pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics